The Cube-Query-Languages (CQL) for Multidimensional Statistical and Scientific Database Systems
نویسندگان
چکیده
The “Cube-Query-Language” (CQL) is a new query language forjexible access to Multidimensional Database Systems. CQL provides a high level user intelface for specifying queries in the context of multidimensional data analysis. The multidimensional view is widely accepted for typical decision support requirements like “Online Analytical Processing “. CQL directly supports this view and circumvents the problems offormulating multiple groupby’s and equijoins in a typical SQL-notation. Furthermore, in comparison to currently available OLAP-solutions, C&L provides a SQL like query interface, making it easy for an experienced SQL-programmer to formulate decision support queries eficiently. The paper details the two-step query processing found in the CQL approach: “data querying” and “‘data presentation”. This description of the query language design is accompanied by a lot of examples, stemming from a joint research project with our industrial partner thus showing the expressive power andflexibility of the query language design.
منابع مشابه
انتخاب مناسبترین زبان پرسوجو برای استفاده از فراپیوندها جهت استخراج دادهها در حالت دیتالوگ در سامانه پایگاه داده استنتاجی DES
Deductive Database systems are designed based on a logical data model. Data (as opposed to Relational Databases Management System (RDBMS) in which data stored in tables) are saved as facts in a Deductive Database system. Datalog Educational System (DES) is a Deductive Database system that Datalog mode is the default mode in this system. It can extract data to use outer joins with three query la...
متن کاملExtension of CQL over Dynamic Databases
CQL, Continuous Query Language is suitable for data stream queries. Sometimes it is better if the queries operate on relational databases and data streams simultaneously. The execution of a CQL query takes a long time (several hours, days or even more). It is not clear what kind of semantics is suitable for the user when the database is updated during the execution of a CQL query. In this paper...
متن کاملHow to integrate Smart Cards in Standard Software without writing specific code ?
When you add a CD-ROM reader to your computer, this new device becomes integrated in part of your environment. The CD-ROM performs like a floppy disk. When using a spreadsheet and a word-processing, if you cut some cells in the first application you can paste these cells in the second application. These two services are provided by application software and operating systems (Windows for PC or S...
متن کاملEvaluating Multidimensional Queries by Diamond Dicing
Queries that constrain multiple dimensions simultaneously are difficult to express and compute efficiently in both Structured Query Language (SQL) and multidimensional languages. We introduce the diamond cube operator to facilitate the expression of one such class of multidimensional query. We have developed, implemented and tested algorithms to compute diamonds on both real and synthetic large...
متن کاملCAL: A Generic Query and Analysis Language for Data Warehouses
Data warehouses (DWs) and OLAP systems are essential tools in organizational decision making. However, users of these systems are often provided with complex data models and system-specific GUIs and dashboards to analyze the data and generate reports. Available DW query languages like MDX and Oracle OLAP support only numeric data and moreover require skilled DW developers to design queries. Thi...
متن کامل